CREATE      VIEW Login_Security_Group
AS
  SELECT a.ID,
     b.ContactID,
         b.ContactID AS MemberID,
         MEMBER_TYPE AS SecurityGroupCode
    FROM Name a, Name_Security b
   WHERE a.ID = b.ID
  UNION
  SELECT c.ID,
     b.ContactID,
         b.ContactID AS MemberID,
         a.SECURITY_GROUP AS SecurityGroupCode
    FROM Name_Security_Groups a, Name_Security b, Name c
   WHERE a.ID = b.ID
     AND a.ID = c.ID
     AND b.EXPIRATION_DATE > CURRENT_TIMESTAMP

GO
GRANT SELECT ON  [dbo].[Login_Security_Group] TO [IMIS]
GO